using Abc.Core.Entities;

using Furion.DatabaseAccessor;

namespace Abc.Application
{
    public interface ISql : ISqlDispatchProxy
    {
        //// 执行sql并传入参数，对象类型
        //[SqlExecute(@"
        //    select * from Admin;
        //    select * from Role;
        //    select * from Menu;")]
        //(List<Admin>, List<Role>, List<Menu>) GetAdminRoleMenuFunctionData();

        //// 执行sql并传入参数，对象类型
        //[SqlExecute(@"
        //    select * from Admin")]
        //List<Admin> GetAllAdmin();

        //// 执行sql并传入参数，对象类型
        //[SqlExecute(@"
        //    select * from Role;")]
        //List<Admin> GetAllRole();

        //// 执行sql并传入参数，对象类型
        //[SqlExecute(@"
        //    select * from Menu;")]
        //List<Admin> GetAllMenu();

        //// 执行sql并传入参数，对象类型
        //[SqlExecute(@"
        //    select * from Function;")]
        //List<Admin> GetAllFunction();

        [SqlExecute(@"select * from DataConfig where Id=@id")]
        DataConfig GetDataConfigById(int id);
    }
}